VBScript and Xpath excluding duplicates [closed]

Posted by Malachi on Programmers See other posts from Programmers or by Malachi
Published on 2012-09-28T16:15:29Z Indexed on 2012/09/28 21:50 UTC
Read the original article Hit count: 277

Filed under:
|

I am trying to pull names from an XML Document using a vbscript.

XML Document structure

<Aliases>
    <Alias PartyType="DF" CaseID="000000" NameType=""> Name Name</Alias>
    <Alias PartyType="DF" CaseID="000000" NameType=""> Name Name</Alias>
    <Alias PartyType="DF" CaseID="000000" NameType=""> Name Name</Alias>
    ...
</Aliases>

the XML File might have 100 rows with the same name coming from several different CaseID's because for this part of my vbscript I am trying to pull all the different Names from all cases, but here is the issue, I don't want to return duplicates.

is there a way to do this with an xPath Expression or should I try to do this with VBScript?

EDIT I am pretty sure that I am going to have to do this with VBScript.

Would it be Faster and more efficient to solve this issue in VBScript, xPath, or in populating the XML I am retrieving information from ( this might prove more difficult than the other two options )

I am also asking a Similar question on stackoverflow

© Programmers or respective owner

Related posts about Xml

Related posts about xpath